<?php
require("../../inc/header.php");

/*
		SoftName : EmpireBak Version 2010
		Author   : wm_chief
		Copyright: Powered by www.phome.net
*/

DoSetDbChar('utf8');
E_D("DROP TABLE IF EXISTS `ecm_brand`;");
E_C("CREATE TABLE `ecm_brand` (
  `brand_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `brand_name` varchar(100) NOT NULL DEFAULT '',
  `brand_logo` varchar(255) DEFAULT NULL,
  `sort_order` tinyint(3) unsigned NOT NULL DEFAULT '255',
  `recommended` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `store_id` int(10) unsigned NOT NULL DEFAULT '0',
  `if_show` tinyint(2) unsigned NOT NULL DEFAULT '1',
  `tag` varchar(100) NOT NULL DEFAULT '',
  PRIMARY KEY (`brand_id`),
  KEY `tag` (`tag`)
) ENGINE=MyISAM AUTO_INCREMENT=18 DEFAULT CHARSET=utf8");
E_D("replace into `ecm_brand` values('1','麦包包','data/files/mall/brand/1.gif','1','1','0','1','');");
E_D("replace into `ecm_brand` values('2','ESprit','data/files/mall/brand/2.jpg','2','1','0','1','');");
E_D("replace into `ecm_brand` values('3','李宁','data/files/mall/brand/3.jpg','3','1','0','1','');");
E_D("replace into `ecm_brand` values('4','G-Star','data/files/mall/brand/4.jpg','4','1','0','1','');");
E_D("replace into `ecm_brand` values('5','Lee','data/files/mall/brand/5.jpg','5','1','0','1','');");
E_D("replace into `ecm_brand` values('6','Jack & Jones','data/files/mall/brand/6.jpg','6','1','0','1','');");
E_D("replace into `ecm_brand` values('7','DIOR','data/files/mall/brand/7.jpg','6','1','0','1','');");
E_D("replace into `ecm_brand` values('8','Chanel','data/files/mall/brand/8.jpg','7','1','0','1','');");
E_D("replace into `ecm_brand` values('9','PUMA','data/files/mall/brand/9.jpg','8','1','0','1','');");
E_D("replace into `ecm_brand` values('10','美特斯邦威','data/files/mall/brand/10.jpg','9','1','0','1','');");
E_D("replace into `ecm_brand` values('11','Adidas','data/files/mall/brand/11.jpg','10','1','0','1','');");
E_D("replace into `ecm_brand` values('12','Nike','data/files/mall/brand/12.jpg','11','1','0','1','');");
E_D("replace into `ecm_brand` values('13','新锐视觉',NULL,'30','1','0','1','婚纱摄影');");
E_D("replace into `ecm_brand` values('14','郎才女貌婚纱摄影',NULL,'31','1','0','1','婚纱摄影');");
E_D("replace into `ecm_brand` values('15','小丑鲜花',NULL,'32','1','0','1','婚庆用品');");
E_D("replace into `ecm_brand` values('16','巴黎风尚',NULL,'34','1','0','1','婚纱摄影');");
E_D("replace into `ecm_brand` values('17','江南游',NULL,'35','1','0','1','蜜月之旅');");

require("../../inc/footer.php");
?>